package cn.tedu.springbootdemo.tedu;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class Demo02 {
    public static void main(String[] args) throws SQLException {
        //获取数据库对象
        Connection conn = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/empdb?" +
                        "characterEncoding=utf8" +
                        "&serverTimezone=GMT%2B8&useSSl=false",
                "root","111112");
        System.out.println("链接对象"+conn);
        //2.创建执行sql语句的对象
        Statement s = conn.createStatement();
        //执行sql语句
        s.execute(" drop table zhangsan");
        //4.关闭资源
        conn.close();

        System.out.println("执行完毕");

    }
}
